[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '20' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55 | 12.45 | 1996-11-25 | Production | david2@adventure-works.com | David Ortiz | 712-555-0119 | 36151748 | David | M | 2020-11-11 | Ortiz | adventure-works\david2 | M | J | 20 | 1 | 712-555-0119 | | 36 | 2020-11-11 | Current | Production Technician - WC60 | 33 |
| 178 | 12.45 | 2003-03-03 | Production | steve0@adventure-works.com | Steve Masters | 712-555-0170 | 752513276 | Steve | M | 2021-01-12 | Masters | adventure-works\steve0 | S | F | 20 | 1 | 712-555-0170 | | 35 | 2021-01-12 | Current | Production Technician - WC60 | 31 |
| 223 | 12.45 | 1983-07-30 | Production | charles0@adventure-works.com | Charles Fitzgerald | 931-555-0118 | 537092325 | Charles | M | 2021-10-30 | Fitzgerald | adventure-works\charles0 | S | B | 20 | 1 | 931-555-0118 | | 33 | 2021-10-30 | Current | Production Technician - WC60 | 27 |
| 212 | 12.45 | 1988-01-08 | Production | jay0@adventure-works.com | Jay Adams | 407-555-0165 | 63179277 | Jay | M | 2021-01-30 | Adams | adventure-works\jay0 | S | G | 20 | 1 | 407-555-0165 | | 36 | 2021-01-30 | Current | Production Technician - WC60 | 32 |
| 230 | 12.45 | 1982-02-01 | Production | karan0@adventure-works.com | Karan Khanna | 447-555-0186 | 834186596 | Karan | M | 2021-11-18 | Khanna | adventure-works\karan0 | S | R | 20 | 1 | 447-555-0186 | | 34 | 2021-11-18 | Current | Production Technician - WC60 | 28 |
| 247 | 12.45 | 1966-12-27 | Production | maciej0@adventure-works.com | Maciej Dusza | 237-555-0128 | 414476027 | Maciej | M | 2021-12-26 | Dusza | adventure-works\maciej0 | S | W | 20 | 1 | 237-555-0128 | | 35 | 2021-12-26 | Current | Production Technician - WC60 | 30 |
| 258 | 12.45 | 1985-08-02 | Production | michael7@adventure-works.com | Michael Zwilling | 582-555-0148 | 582347317 | Michael | M | 2022-01-20 | Zwilling | adventure-works\michael7 | S | J | 20 | 1 | 582-555-0148 | | 33 | 2022-01-20 | Current | Production Technician - WC60 | 26 |
| 259 | 12.45 | 1982-03-25 | Production | randy0@adventure-works.com | Randy Reeves | 961-555-0122 | 8066363 | Randy | M | 2022-01-20 | Reeves | adventure-works\randy0 | M | T | 20 | 1 | 961-555-0122 | | 34 | 2022-01-20 | Current | Production Technician - WC60 | 29 |
Generated 2026-05-27 14:31:59.494 UTC